create table [OpenXML_DB].[dbo].[Applicant]
(
ApplicantID varchar(4) Constraint PK_Applicant PRIMARY KEY not null,
ApplicantLastName varchar(50),
ApplicantMiddleName varchar(50),
ApplicantFirstName varchar(50),
ApplicantEmail varchar(50),
ApplicantCountry varchar(50),
ApplicantNationality varchar(30),
ApplicantNationality2 varchar(30),
ApplicantPhoneNumber varchar(30),
ApplicantGender int,
ApplicantCurrentYear varchar(2),
ApplicantApplyingfor varchar(2)
);